#!/usr/bin/env python
# -*- coding: utf-8 -*-
# @Date    : 2022
# @Author  : lingfeng.hu@nokia-sbell.com)
# @Link    : TBD
# @Version : $Id$

# https://jiradc.ext.net.nokia.com/rest/api/2/issue/FPB-662472
# from CollectL3HzFBData import getTeam
from jira import JIRA
from openpyxl import Workbook, load_workbook
from time import strftime, localtime
from datetime import datetime

# wb = load_workbook(filename='Backlog_20220124173701.xlsx')
# backlogCASheet = wb['Backlog_CA']
# TotalRowNum = backlogCASheet.max_row
# TotalColNum = backlogCASheet.max_column

# print("backlogCASheet TotalRowNum: {}, TotalColNum: {}".format(TotalRowNum, TotalColNum))

wb_5G = load_workbook(filename='5G_L3_CN_SW_1.xlsx')
backlogCASheet_5G = wb_5G['Backlog_CA']
print("backlogCASheet_5G TotalRowNum: {}, TotalColNum: {}".format(backlogCASheet_5G.max_row, backlogCASheet_5G.max_column))


# for row in range(backlogCASheet.max_row):
#     for col in range(backlogCASheet.max_column):
#         print('row: {}, col: {}, value: {}'.format(row+2, col+1, backlogCASheet.cell(row=row+2, column=col+1).value))
#         backlogCASheet_5G.cell(row=row+2, column=col+1).value = backlogCASheet.cell(row=row+2, column=col+1).value

# if backlogCASheet_5G.max_row > TotalRowNum:
#     backlogCASheet_5G.delete_rows(backlogCASheet_5G.max_row-TotalRowNum+1, backlogCASheet_5G.max_row-TotalRowNum)

# today = strftime("%Y-%m-%d", localtime())
# startTime = datetime.now()



# print('collection done in {}'.format(outputFile))